There are 340 shooting incidents occurs in the United States in 2018. In total, 373 lives lost in the shooting incidents. The city with most impacted, which is the city with most occurrence of shooting incidents, is Chicago. The city with most killed people is Pompano Beach (Parkland). The city with most injured people in shooting accidents is Chicago.
## Selecting by num_killed
## Warning: Ignoring unknown aesthetics: text
| city | total_num_killed | total_num_injured |
|---|---|---|
| Pompano Beach (Parkland) | 17 | 17 |
| Chicago | 13 | 122 |
| Philadelphia | 13 | 36 |
| Thousand Oaks | 13 | 2 |
| Pittsburgh | 11 | 7 |
| Detroit | 10 | 10 |
| Santa Fe | 10 | 13 |
| New Orleans | 9 | 26 |
| Bakersfield | 7 | 4 |
| Jacksonville | 7 | 23 |
| Los Angeles | 7 | 19 |
| Orlando | 7 | 13 |
| Cleveland | 6 | 18 |
| Annapolis | 5 | 0 |
| Bloomington | 5 | 3 |
| Columbia | 5 | 0 |
| Melcroft | 5 | 0 |
| Memphis | 5 | 38 |
| Paintsville | 5 | 0 |
| Ponder | 5 | 1 |
| Robstown | 5 | 0 |
| Wilmington | 5 | 0 |
| Aberdeen | 4 | 3 |
| Antioch | 4 | 3 |
| Asheville | 4 | 3 |
| Cincinnati | 4 | 6 |
| Clearlake | 4 | 1 |
| Gallup | 4 | 1 |
| Indianapolis | 4 | 5 |
| Miami | 4 | 21 |
| Nashville | 4 | 6 |
| Palm Beach Gardens (Riviera Beach) | 4 | 10 |
| Reading | 4 | 0 |
| Saint Charles | 4 | 1 |
| Saint Louis | 4 | 34 |
| Silver Spring | 4 | 1 |
| Taft | 4 | 1 |
| Aurora | 3 | 13 |
| Baton Rouge | 3 | 1 |
| Buffalo | 3 | 11 |
| Colorado Springs | 3 | 7 |
| Dunn | 3 | 1 |
| Fort Wayne | 3 | 2 |
| Globe | 3 | 1 |
| Houston | 3 | 13 |
| Lake Worth (Lantana) | 3 | 3 |
| Las Vegas | 3 | 15 |
| Little Rock | 3 | 1 |
| Oakland | 3 | 15 |
| San Francisco | 3 | 14 |
| Stockton | 3 | 2 |
| Tallahassee | 3 | 5 |
| Timmonsville | 3 | 2 |
| Wadesboro | 3 | 1 |
| Wetumpka | 3 | 2 |
| Benton | 2 | 14 |
| Brooklyn | 2 | 11 |
| Demopolis | 2 | 2 |
| El Dorado | 2 | 2 |
| Florence | 2 | 6 |
| Gardena | 2 | 3 |
| Gary | 2 | 6 |
| Hurtsboro | 2 | 2 |
| Lima | 2 | 8 |
| Lutcher | 2 | 2 |
| Palo Alto (East Palo Alto) | 2 | 2 |
| Paterson | 2 | 6 |
| Saint Robert (St Robert) | 2 | 2 |
| Seattle (Skyway) | 2 | 2 |
| Springfield | 2 | 9 |
| Vallejo | 2 | 7 |
| Washington | 2 | 23 |
| Ashburn | 1 | 6 |
| Atlanta | 1 | 7 |
| Auburn | 1 | 4 |
| Bradenton | 1 | 5 |
| Brinkley | 1 | 3 |
| Champaign | 1 | 3 |
| Cleveland (Garfield Heights) | 1 | 5 |
| Compton | 1 | 3 |
| Denver | 1 | 8 |
| Elgin | 1 | 3 |
| Espanola (Española) | 1 | 3 |
| Eutaw | 1 | 4 |
| Fort Lauderdale (Lauderhill) | 1 | 3 |
| Hazlehurst | 1 | 7 |
| Hickory | 1 | 3 |
| Homestead (Munhall) | 1 | 3 |
| Huntsville | 1 | 7 |
| Indianapolis (Lawrence) | 1 | 4 |
| Jackson | 1 | 4 |
| Jersey City | 1 | 8 |
| Kansas City | 1 | 13 |
| Lakewood | 1 | 3 |
| Laurinburg | 1 | 3 |
| Los Angeles (Watts) | 1 | 4 |
| Macon | 1 | 3 |
| Masontown | 1 | 4 |
| Middleton | 1 | 4 |
| Minneapolis | 1 | 14 |
| Mobile | 1 | 4 |
| Monroe | 1 | 3 |
| Natchitoches | 1 | 3 |
| Oklahoma City | 1 | 7 |
| Omaha | 1 | 16 |
| Phoenix | 1 | 4 |
| Pine Bluff | 1 | 7 |
| Plano | 1 | 3 |
| Richmond | 1 | 8 |
| Rockford | 1 | 4 |
| San Bernardino | 1 | 11 |
| Sanford | 1 | 6 |
| Sunnyside | 1 | 4 |
| Talihina | 1 | 4 |
| Thornton | 1 | 3 |
| Tracy | 1 | 4 |
| Trenton | 1 | 23 |
| Union Springs | 1 | 5 |
| Virginia Beach | 1 | 9 |
| West Palm Beach | 1 | 3 |
| Westminster | 1 | 3 |
| Wichita Falls | 1 | 3 |
| Alachua | 0 | 5 |
| Albany | 0 | 8 |
| Anderson | 0 | 4 |
| Asbury Park | 0 | 5 |
| Baldwin Park | 0 | 4 |
| Baltimore | 0 | 23 |
| Birmingham | 0 | 11 |
| Boston | 0 | 4 |
| Bowling Green | 0 | 4 |
| Brandon | 0 | 6 |
| Bridgeport | 0 | 4 |
| Bronx | 0 | 8 |
| Byhalia | 0 | 4 |
| Camden | 0 | 4 |
| Charlotte | 0 | 4 |
| Chattanooga | 0 | 5 |
| Chicago Heights | 0 | 4 |
| Columbus | 0 | 9 |
| Corona (Queens) | 0 | 5 |
| Covington | 0 | 4 |
| Dallas | 0 | 11 |
| Elizabeth | 0 | 4 |
| Flint | 0 | 4 |
| Fort Smith | 0 | 4 |
| Fort Washington | 0 | 4 |
| Fort Worth | 0 | 4 |
| Greenwood | 0 | 5 |
| Hartford | 0 | 4 |
| Harvey | 0 | 4 |
| Hattiesburg | 0 | 6 |
| Hempstead | 0 | 4 |
| Henderson | 0 | 4 |
| Indiantown | 0 | 4 |
| Inglewood | 0 | 5 |
| Kannapolis | 0 | 4 |
| Lansing | 0 | 4 |
| Long Beach (North Long Beach) | 0 | 4 |
| Louisville | 0 | 7 |
| Macclenny | 0 | 4 |
| Madison | 0 | 8 |
| Maxton | 0 | 5 |
| Milwaukee | 0 | 8 |
| Modesto | 0 | 9 |
| Montgomery | 0 | 4 |
| Morganza | 0 | 4 |
| New Orleans (Algiers) | 0 | 4 |
| Paulsboro | 0 | 4 |
| Pittsburgh (East Liberty) | 0 | 4 |
| Plantation | 0 | 4 |
| Pompano Beach | 0 | 4 |
| Powell | 0 | 4 |
| Punta Gorda | 0 | 4 |
| Reddick | 0 | 4 |
| Riverside | 0 | 7 |
| Saginaw | 0 | 10 |
| Salt Lake City (West Valley City) | 0 | 4 |
| San Antonio | 0 | 13 |
| San Diego | 0 | 5 |
| Sandusky | 0 | 5 |
| Savannah | 0 | 4 |
| Shreveport | 0 | 10 |
| South Bend | 0 | 6 |
| Spartanburg | 0 | 6 |
| Stillwater | 0 | 4 |
| Swainsboro | 0 | 4 |
| Syracuse | 0 | 5 |
| Tulsa | 0 | 4 |
| Union City | 0 | 5 |
| Valley Village | 0 | 6 |
| Wartburg | 0 | 4 |
| Watertown | 0 | 5 |
| Wichita | 0 | 4 |
| Wyncote | 0 | 5 |
| York | 0 | 4 |
In the table, we can apparently see that the city with the most number of people being killed is Pompano Beach (Parkland), in which I defined as the most dangerous city. And that the city with the most people being injured in 2018 is Chicago.
There is a car-to-car shooting event happens on December 8, 2018, near 801 S Inglewood Ave, Inglewood, California. 0 people was being killed, 5 people was being injured, including at least two boys. According to Los Angeles Sheriff’s Department, the events happened at 9pm. There are two bystander who are also caught in the gunfire. More information can be found on https://ktla.com/2018/12/09/5-people-including-2-boys-hurt-in-car-to-car-shooting-in-inglewood-area-officials/
Question: How do cities with top 10 most shooting murders compared with each other?
## Selecting by num_killed
## Warning: Ignoring unknown aesthetics: text